<?php
/**
 * ShopEx licence
 *
 * @copyright  Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn)
 * @license  http://ecos.shopex.cn/ ShopEx License
 */

$db['feedback']=array (
  'columns' =>
  array (
    'id' =>
    array (
      'type' => 'number',
      'required' => true,
      'pkey' => true,
      'extra' => 'auto_increment',
      'label' => app::get('b2c')->_('反馈表ID'),
      'width' => 150,
      'comment' => app::get('b2c')->_('反馈表ID'),
      'editable' => false,
      'in_list' => false,
      'default_in_list' => true,
    ),
    'member_id' =>
    array (
      'type' => 'table:members',
      'default' => 0,
      'required' => true,
      'editable' => false,
      'comment' => app::get('b2c')->_('会员ID'),
    ),
	'phone_setting' => 
    array(
       'type' => 'varchar(20)',
       'editable' => false,
	   'label' => app::get('b2c')->_('电话区号'),
       'comment' => app::get('b2c')->_('电话区号'),
	   'in_list' => true,
	   'default_in_list' => true,
    ),
    'tel' =>
    array (
      'type' => 'varchar(50)',
      'label' => app::get('b2c')->_('电话'),
      'width' => 110,
      'searchtype' => 'head',
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => true,
    ),
    'name' =>
    array (
      'type' => 'varchar(200)',
      'label' => app::get('b2c')->_('姓名'),
      'width' => 110,
      'default' => '',
      'searchtype' => 'has',
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => true,
    ),
	'content' =>
    array (
      'type' => 'text',
      'label' => app::get('b2c')->_('反馈意见'),
      'width' => 110,
      'default' => '',
      'searchtype' => 'has',
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => true,
    ),
    'regtime' =>
    array (
      'label' => app::get('b2c')->_('注册时间'),
      'width' => 75,
      'type' => 'time',
      'editable' => false,
      'filtertype' => 'time',
      'filterdefault' => true,
      'in_list' => true,
      'default_in_list' => true,
      'comment' => app::get('b2c')->_('注册时间'),
    ),
    'state'=>
	array (
      'type' => 
      array (
        'Y' => app::get('b2c')->_('已处理'),
        'N' => app::get('b2c')->_('未处理'),
      ),
	  'default'=>'N',
      'label' => app::get('b2c')->_('反馈意见处理状态'),
      'editable' => false,
      'in_list' => true,
    ),
  ),
  'engine' => 'innodb',
  'version' => '$Rev: 42798 $',
  'comment' => app::get('b2c')->_('信息反馈表'),
);